home *** CD-ROM | disk | FTP | other *** search
-
- WHAT:- 93PLAN.XLS & 93PLAN.TXT (this file) for Excel ver 4.0
- WHO:- Dizzy Gosnell 70162,530.
- WHEN:- Jan 6th 1993.
- WHY:- Other calenders are too big,clumsy,and expensive.
- HOW MUCH:- Free, Nothing, Nada, Zip, Zero.
- LIABILITY:- None.
-
- This is just a basic year planner for 1993, it has no fancy
- bells & whistles or macros attatched to it. It is just intended as
- a more portable alternative to the $40 planner you stick on your
- wall. Oh yes, you can print it too.
-
- Hints:
-
- 1] All of the bars, text labels & colours can be drawn using the
- "drawing" toolbar in Excel 4.0 .
-
- 2] To create the bars, I suggest using the "filled box"
- tool,(shown on the button in the toolbar as a filled square) this
- enables you to stretch or shrink the bar to suit, also you can copy
- the bar over a series of months or drag it over if you change dates.
-
- 3] To change colours, use the "pallette" tool in the drawing
- toolbar to cycle through the colors of your choice.
-
- 4] To add a label use the "text box" button on the drawing
- toolbar and size it to fit, I suggest using the "small fonts" font at
- about 6 points. When you enter the text if it "drops off the edge"
- you can stretch it to suit after the text is entered so you can see
- it all. Again you can hold down the CTRL key and copy it to another
- month if needed this saves typing it out all over again. Also you can
- use the colour "pallette" tool to cycle through the desired
- background colour of the box.
-
- 5] You could get really flash and add buttons to certain days of
- the month to fire up macros, spreadsheets etc if you wish.
-
- 6] I have set it up on the OPTIONS*DISPLAY menu to have the row &
- column headings off to give more screen to the planner, if you
- want to increase the row height to accomodate more bars & labels,
- or insert more rows to define different departments, projects etc,
- you would need to turn row & columns back on to increase it.
- Likwise you could increase the coloumn width.
-
-
- Have fun, and I hope this helps.
-
- Diz.
-